Fabric Warehouse supports varchar (MAX), so the 8000-character cap is an unnecessary hard limit that silently truncates any string column produced through these code paths. If I used the max of 8000, a error would result in an empty parquet file with no error message. A better solution when using the data gateway and various source databases is to have an option to allow for string truncation. As stated, there are multiple ways to define a text column and while you cannot use VarcharType/CharType in your Spark dataframe, you can still use it to define the output tables of your lakehouse. Inspired by this blog post by Kyle Hale, I was running some similar tests on Microsoft Fabric. PRINT (Transact-SQL) A message string can be up to 8,000 characters long if it's a non-Unicode string, and 4,000 characters long if it's a Unicode string. Longer strings are truncated. The varchar (max) and nvarchar (max) data types are truncated to data types that are no larger than varchar (8000) and nvarchar (4000). RAISERROR can also be used to return messages. RAISERROR has these. Columns containing more than 8000 characters are getting silently truncated when Dataflow Gen2 take source Lakehouse table (Delta). Truncation errors in Fabric are about byte length, not character length. Changing the collation to a UTF‑8 one ensures that characters like Ö are stored correctly, but it does not change the byte limit of the column. Some rows contain more than 8000 characters, which causes the copy job to fail. Is there a recommended way to truncate the data to 8000 characters during the copy process to avoid this error? Some rows contain more than 8000 characters, which causes the copy job to fail. Is there a recommended way to truncate the data to 8000 characters during the copy process to avoid this error? This update allows you to use Fabric Lakehouse's SQL endpoint on fields larger than 8,000 characters.The introduction of the VARCHAR(MAX) and VARBINARY(MAX) types allows for storing larger data, such as text in JSON format, without truncation issues. Columns containing more than 8000 characters are getting silently truncated when Dataflow Gen2 take source Lakehouse table (Delta).